Show AllReturns or sets which axes exist on the chart. Read/write Variant.
expression.HasAxis(Index1, Index2)
expression Required. An expression that returns one of the objects in the Applies To list.
Index1 Optional XlAxisType. The type of axis.
| XlAxisType can be one of these XlAxisType constants. |
| xlCategory |
| xlValue
xlSeriesAxis. Series axes apply only to 3-D charts. |
Index2 Optional XlAxisGroup. The axis priority.
| XlAxisGroup can be one of these XlAxisGroup constants. |
| xlPrimary |
| xlSecondary
3-D charts have only one set of axes. |
Microsoft Graph may create or delete axes if you change the chart type or change the AxisGroup property.
This example turns on the primary value axis.
myChart.HasAxis(xlValue, xlPrimary) = True